/*******************************************************************************
 * This file is part of blueprint4j www.blueprint4j.org.
 * 
 *     blueprint4j is free software: you can redistribute it and/or modify
 *     it under the terms of the GNU Lesser General Public License as published by
 *     the Free Software Foundation, either version 3 of the License, or
 *     (at your option) any later version.
 * 
 *     blueprint4j is distributed in the hope that it will be useful,
 *     but WITHOUT ANY WARRANTY; without even the implied warranty of
 *     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *     GNU Lesser General Public License for more details.
 * 
 *     You should have received a copy of the GNU Lesser General Public License
 *     along with blueprint4j. If not, see <http://www.gnu.org/licenses/>.
 ******************************************************************************/
package blueprint4j.db;

import java.math.BigDecimal;
import java.math.BigInteger;
import java.text.DateFormat;
import java.text.ParseException;
import java.util.Date;
import java.sql.*;


public class FieldCombiner extends FieldString  {

	private Field[] fields;

	/**
	 * public Field( String p_name, String p_description, boolean p_key_field
	 *
	 * Name: Name of field -> equivalent to table.field_name
	 * Description: Description of field
	 * key_field: Is this field a key field in the table (index field)
	 */
	public FieldCombiner( String name, String p_description, Field[] p_fields ,Entity entity) {
		super(name, FIELD_NOT_REAL,p_description,0,entity );
		fields=p_fields;
	}

	public Field newInstance(Entity entity) {
		return new FieldCombiner(getName(),getDescription(),fields,entity);
	}

	protected void setFieldValue( ResultSet result_set )
	throws DataException {
		throw new DataException("Attempt to set a field binder");
	}

	public String get() {
		String value="";
		for (int t=0;t<fields.length;t++){
			Object o=fields[t].getObject();
			if (value.length()>0 && o!=null && (""+o).length()>0){
				value=value+", ";
			}
			if (o!=null){
				value=value+o;
			}
		}
		return value;
	}

	public void set(String value) {}
	
	public Field [] getFields() {
		return fields;
	}

	/**
	 * Return data in a suitable SQL format
	 */
	public String getSQLValue()
	throws DataException {
		throw new DataException("Attempt to use a field bindser in an SQL function");
	}

	public String toString(){
		return get();
	}
}
